<?php
include_once("../commonFunctions.php");
class TTStatusChange {

    var $id;
    var $dateTimeChange;
    var $modifiedBy;
    var $notes;
    var $status;

    function __construct($TTID) {
        $query = "select * from ttstatuschange where id='" . $TTID . "';";
        $result = mysql_query($query) or die("query failed in TTStatusChange.php");
        if (mysql_num_rows($result) > 0) {
            $row = mysql_fetch_array($result, MYSQL_ASSOC);
            $this->id = $row['id'];
            $this->dateTimeChange = $row['dateTimeChange'];
            $this->modifiedBy = $row['modifiedBy'];
            $this->notes = $row['notes'];
            $this->status = $row['status'];
        } else {
            return null;    // TTStatusChange doesn't exist
        }
    }

}

?>
